package com.ncloud.act.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.ncloud.act.entity.PaymentDeposit;

@Mapper
public interface PaymentDepositMapper{

	@Select("SELECT payment_id, pay_fee_mode_code, deposit_code, invoice_tag, remark "
			+ "FROM bi_d_payment_deposit where payment_id=#{payment_id} and pay_fee_mode_code=#{pay_fee_mode_code}")
	@Results({@Result(column="payment_id",property="payment_id"),@Result(column="pay_fee_mode_code",property="pay_fee_mode_code"),
		@Result(column="deposit_code",property="deposit_code"),@Result(column="invoice_tag",property="invoice_tag"),
		@Result(column="remark",property="remark")})
	List<PaymentDeposit> getPaymentDepositByPaymentID(@Param("payment_id")String payment_id,@Param("pay_fee_mode_code")String pay_fee_mode_code);
}
